home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Developer Source 4
/
developer source - volume 4.iso
/
oracl
/
may95
/
aultf101.gif
< prev
next >
Graphics Interchange Format
|
1996-06-11
|
257KB
|
735x787
|
4-bit (16 colors)
Labels:
text
|
screenshot
|
font
|
menu
|
number
|
document
OCR:
FIGURE 1; The DBMS packages, functions, views, sequences, and tables built for the procedural option DBMSLOCK.SQL FUNCTIONS: LOCAL TRANSACTION_ID" , STEP_ID" PACKAGE !! DBMS LOCK TABLES: DBMS LOCK ALLOCATED PACKAGE: DBMS SESSION SEQUENCES DBMS LOCK_ID PROCEDURES PROCEDURES: SET ROLE, SET_SQL TRACE, SET_NIS; ALLOCATE_UNIQUE, SLEEP, CONVERTBACK FUNCTIONS: REQUEST(TWO), CONVERT, RELEASE(TWO) CLOSE DATABASE LINK, SET_LABEL, SET_MLS_LABEL_FORMAT, RESET_PACKAGE, INTERNAL_REQUEST, INTERNAL_CONVERT; INTERNAL RELEASE FUNCTIONS, SET CLOSE CACHED OPEN CURSORS" UNIQUE SESSION_ID, IS ROLE_ENABLED DBMSPIPE.SQL PACKAGE DBMS_DDL PACKAGE DBMS PIPE PROCEDURES: ALTER COMPILE, ANALYZE_OBJECT PROCEDURES: PACK_MESSAGE(THREE), UNPACK_MESSAGE(THREE), VIEWS: UNPACK _MESSAGE [THREE], RESET_BUFFER, PURGE, ORDER_OBJECT BY DEPENDENCY, SENDPIPE, RECEIVEPIPE, COPYINTOBUF(THREE). DBA ANALYZE_OBJECTS COPYFROMBUFITHREEJ, COPYINTOBUFBINARY *. COPYINTOBUFROWID *, COPYFROMBUFBINARY* PACKAGE: DBMS UTILITY COPYFROMBUFROWID *, PACK_MESSAGE_RAW+, PROCEDURES COMPILE_SCHEMA, ANALYZE_SCHEMA, NAME RESOLVE, NAME_TOKENIZE\ \\ UNPACK_MESSAGE_RAW *, PACK FUNCTIONS: COMMA_TO_TABLE", TABLE_TO_COMMA" FUNCTIONS: MESSAGE_ROWID *, UNPACK_MESSAGE_ROWID* FORMAT_ERROR_STACK, FORMAT_CALL STACK, NEXT ITEM, SEND_MESSAGE, RECEIVE_MESSAGE UNIQUE SESSION_NAME, GETTYPEFROMBUF S PARALLEL SERVER, GET TIME DBMSSNAP.SQL DBMSALRT.SQL PACKAGE: PACKAGE: DBMS ALERT PROCEDURES: DBMS SNAPSHOT "PURGE_LOGITWOJ, REFRESH(TWO), REFRESH_ALL, PROCEDURES SET_DEFAULT, REGISTER, REMOVE, REMOVEALL, DROP_SNAPSHOT, SET_UP, WRAP_UP, GET_LOG_AGE, WAITANY WAITONE, SIGNAL, PIPE_WAIT, FUNCTIONS: OPTIMISTIC , SIGNAL PIPE. TESTING MINIMUM, ALERT_HASH, SESSION_HASH DBMSSQLSQL |Pre-Oracle 7 Release 7.1, UNIX systems ontyl PACKAGE: DBMS SQL DBMSOTPT.SQL PROCEDURES: CLOSE_CURSOR, PARSE, BIND VARIABLE(TEN), PACKAGE: DBMS OUTPUT DEFINE_COLUMN(SEVEN) COLUMN_VALUE(EIGHT), PROCEDURES: ENABLE, DISABLE, PUT[THREE), PUT LINE|THREE), COLUMN VALLIE RAW(TWO), NEW_LINE, GET_LINE, GET_LINES COLUMN VALUE_CHARITWOW COLUMN_VALUE ROWID(TWO), DBMSDESC.SQL VARIABLE_VALUE(FOUR), VARIABLE_VALUE_CHAR, PACKAGE: DBMS DESCRIBE VARIABLE_ VALUE RAW, VARIABLE_VALUE_ROWID PROCEDURES: DESCRIBE PROCEDURE FUNCTIONS: OPEN CURSOR, IS OPEN, EXECUTE, FETCH_ROWS, EXECUTE_AND_FETCH, LAST_ERROR_POSITION, DBMSMAIL.SQL LAST_SQL FUNCTION_CODE, LAST_ROW_COUNT, PACKAGE: DBMS MAIL LAST ROW_ID PROCEDURES: SEND DBMSSYER.SQL Oracle 7 Release 7:1 only) DBMSPOOL.SQL PACKAGE: DBMS SYS_ ERROR PACKAGE: DBMS SHARED POOL PROCEDURES: RAISE SYSTEM_ERROR VIEWS DBA KEEPSIZES* PROCEDURES: DOIT, SIZES, KEEP,UNKEEP DBMSJOB.SQL Oracle7 Release 7 1 only) VIEWS: DBA KEEPSIZES PACKAGE: DBMS JOB PROCEDURES: ISUBMIT, SUBMIT, REMOVE, CHANGE, WHAT," DBMSUTIL.SQL NEXT DATE, INTERVAL, BROKEN, RUN, USER_EXPORT, PACKAGE: DBMS TRANSACTION PROCEDURES READ ONLY, READ WRITE, ADVISE_ROLLBACK, CHECK_PRIVS ADVISE_NOTHING, ADVISE_COMMIT, USE_ROLLBACK_SEGMENT, COMMIT_COMMENT; DBMSDFED.SQL:Oracle/ Release 7. I only) DUMMY PROCEDURE |Private procedure ontyl COMMIT_FORCE, COMMIT, SAVEPOINT, ROLLBACK, ROLLBACK SAVEPOINT, ROLLBACK_FORCE, BEGIN_DISCRETE TRANSACTION, PURGE_MIXED Now in Oracle7 Release 7 1
